CREATE TABLE jms_dm.dm_mng_customer_daliy_project_summary_dt
(
    project_name            string comment '项目名称',
    date_time               date comment '日期',
    waybill_total           int comment '总订单量',
    cancel_num              int comment '总取消量',
    need_taking_num         int comment '应揽收量',
    actual_taking_num       int comment '实际揽收量',
    no_taking_num           int comment '有单未揽收量',
    lack_taking_num         int comment '有单漏揽收量',
    transport_num           int comment '运输中量',
    del_war_num             int comment '派件中量',
    no_saft_num             int comment '未妥投量',
    sign_num                int comment '已签收量',
    intercept_num           int comment '拦截量',
    success_intercept_num   int comment '成功拦截量',
    7d_update_intercept_num int comment '轨迹断更量',
    work_order_num          int comment '客诉量',
    arbitration_num         int comment '丢失量',
    express_num             int comment '丢失量',
    xj_sign                 int comment '虚假签收量'
) ENGINE = OLAP DUPLICATE KEY(project_name)
COMMENT "客服日报汇总"
PARTITION BY RANGE(date_time)
(START ("2022-08-01") END ("2022-08-30") EVERY (INTERVAL 1 day)
)
DISTRIBUTED BY HASH(project_name) BUCKETS 1
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-360",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "1",
"in_memory" = "false",
"storage_format" = "V2"
);
